Release 10.1A: OpenEdge Development:
Basic Database Tools

Index Deactivation option

Choose Utilities Index Deactivation to deactivate indexes. When you choose this option, the Index Deactivation dialog box shown in Figure 11–12 appears.

Figure 11–12: Index Deactivation dialog box

After you read the information, choose OK. The Data Dictionary alphabetically lists all the tables defined for the database. Select the table for which you want to deactivate indexes or enter ALL to deactivate all your indexes. If you specified an individual table, the Data Dictionary lists the indexes defined for that table. Select the indexes you want to deactivate, then press GO. The Data Dictionary prompts you to verify your entry.